Teradata Functions |
您所在的位置:网站首页 › teradata datetime › Teradata Functions |
Date Functions¶
The functions in this section use a format string that is compatible with the Teradata datetime functions. The following table, based on the Teradata reference manual, describes the supported format specifiers: Specifier Description - / , . ; : Punctuation characters are ignored dd Day of month (1-31) hh Hour of day (1-12) hh24 Hour of the day (0-23) mi Minute (0-59) mm Month (01-12) ss Second (0-59) yyyy 4-digit year yy 2-digit year Warning Case insensitivity is not currently supported. All specifiers must be lowercase. to_char(timestamp, format) → varchar¶Formats timestamp as a string using format. to_timestamp(string, format) → timestamp¶Parses string into a TIMESTAMP using format. to_date(string, format) → date¶Parses string into a DATE using format. |
今日新闻 |
点击排行 |
|
推荐新闻 |
图片新闻 |
|
专题文章 |
CopyRight 2018-2019 实验室设备网 版权所有 win10的实时保护怎么永久关闭 |